Dataset statistics
| Number of variables | 3 |
|---|---|
| Number of observations | 125438 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.9 MiB |
| Average record size in memory | 24.0 B |
Variable types
| Categorical | 1 |
|---|---|
| Numeric | 2 |
Reproduction
| Analysis started | 2022-11-22 21:00:25.305250 |
|---|---|
| Analysis finished | 2022-11-22 21:03:09.486625 |
| Duration | 2 minutes and 44.18 seconds |
| Software version | pandas-profiling vdev |
| Download configuration | config.json |
| Distinct | 125438 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 980.1 KiB |
| tt0000003 | 1 |
|---|---|
| tt2188056 | 1 |
| tt21879424 | 1 |
| tt2187932 | 1 |
| tt21879178 | 1 |
| Other values (125433) |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 9.1506242 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1147836 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 125438 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | tt0000003 |
|---|---|
| 2nd row | tt0000033 |
| 3rd row | tt0000035 |
| 4th row | tt0000040 |
| 5th row | tt0000041 |
Common Values
| Value | Count | Frequency (%) |
| tt0000003 | 1 | < 0.1% |
| tt2188056 | 1 | < 0.1% |
| tt21879424 | 1 | < 0.1% |
| tt2187932 | 1 | < 0.1% |
| tt21879178 | 1 | < 0.1% |
| tt21878904 | 1 | < 0.1% |
| tt2187889 | 1 | < 0.1% |
| tt2187887 | 1 | < 0.1% |
| tt2187884 | 1 | < 0.1% |
| tt2187815 | 1 | < 0.1% |
| Other values (125428) | 125428 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| tt0000003 | 1 | < 0.1% |
| tt0000035 | 1 | < 0.1% |
| tt0000041 | 1 | < 0.1% |
| tt0000045 | 1 | < 0.1% |
| tt0000046 | 1 | < 0.1% |
| tt0000060 | 1 | < 0.1% |
| tt0000066 | 1 | < 0.1% |
| tt0000067 | 1 | < 0.1% |
| tt0000069 | 1 | < 0.1% |
| tt0000073 | 1 | < 0.1% |
| Other values (125428) | 125428 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 250876 | |
| 0 | 132397 | |
| 1 | 111959 | |
| 2 | 95976 | 8.4% |
| 4 | 88705 | 7.7% |
| 6 | 85945 | 7.5% |
| 8 | 82876 | 7.2% |
| 3 | 79199 | 6.9% |
| 5 | 77060 | 6.7% |
| 7 | 73393 | 6.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 896960 | |
| Lowercase Letter | 250876 | 21.9% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 132397 | |
| 1 | 111959 | |
| 2 | 95976 | |
| 4 | 88705 | |
| 6 | 85945 | |
| 8 | 82876 | |
| 3 | 79199 | |
| 5 | 77060 | |
| 7 | 73393 | |
| 9 | 69450 |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 250876 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 896960 | |
| Latin | 250876 | 21.9% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 132397 | |
| 1 | 111959 | |
| 2 | 95976 | |
| 4 | 88705 | |
| 6 | 85945 | |
| 8 | 82876 | |
| 3 | 79199 | |
| 5 | 77060 | |
| 7 | 73393 | |
| 9 | 69450 |
Latin
| Value | Count | Frequency (%) |
| t | 250876 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1147836 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 250876 | |
| 0 | 132397 | |
| 1 | 111959 | |
| 2 | 95976 | 8.4% |
| 4 | 88705 | 7.7% |
| 6 | 85945 | 7.5% |
| 8 | 82876 | 7.2% |
| 3 | 79199 | 6.9% |
| 5 | 77060 | 6.7% |
| 7 | 73393 | 6.4% |
averageRating
Real number (ℝ)
| Distinct | 91 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.9464819 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 980.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4.4 |
| Q1 | 6.2 |
| median | 7.1 |
| Q3 | 7.9 |
| 95-th percentile | 8.9 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 1.7 |
Descriptive statistics
| Standard deviation | 1.3901457 |
|---|---|
| Coefficient of variation (CV) | 0.20012227 |
| Kurtosis | 1.117804 |
| Mean | 6.9464819 |
| Median Absolute Deviation (MAD) | 0.8 |
| Skewness | -0.80419873 |
| Sum | 871352.8 |
| Variance | 1.9325051 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7.4 | 4599 | 3.7% |
| 7.2 | 4522 | 3.6% |
| 7.6 | 4423 | 3.5% |
| 7.8 | 4393 | 3.5% |
| 7 | 4313 | 3.4% |
| 7.7 | 4048 | 3.2% |
| 8 | 4025 | 3.2% |
| 7.5 | 3977 | 3.2% |
| 7.3 | 3965 | 3.2% |
| 6.8 | 3913 | 3.1% |
| Other values (81) | 83260 |
| Value | Count | Frequency (%) |
| 1 | 110 | |
| 1.1 | 22 | < 0.1% |
| 1.2 | 56 | |
| 1.3 | 28 | < 0.1% |
| 1.4 | 47 | |
| 1.5 | 30 | < 0.1% |
| 1.6 | 45 | |
| 1.7 | 37 | < 0.1% |
| 1.8 | 48 | |
| 1.9 | 56 |
| Value | Count | Frequency (%) |
| 10 | 610 | |
| 9.9 | 107 | 0.1% |
| 9.8 | 261 | 0.2% |
| 9.7 | 226 | 0.2% |
| 9.6 | 374 | |
| 9.5 | 330 | 0.3% |
| 9.4 | 514 | |
| 9.3 | 511 | |
| 9.2 | 860 | |
| 9.1 | 745 |
numVotes
Real number (ℝ)
| Distinct | 5577 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 939.27737 |
| Minimum | 5 |
|---|---|
| Maximum | 1326662 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 980.1 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 12 |
| median | 26 |
| Q3 | 100 |
| 95-th percentile | 1316 |
| Maximum | 1326662 |
| Range | 1326657 |
| Interquartile range (IQR) | 88 |
Descriptive statistics
| Standard deviation | 14122.848 |
|---|---|
| Coefficient of variation (CV) | 15.035865 |
| Kurtosis | 2281.1966 |
| Mean | 939.27737 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | 40.608698 |
| Sum | 1.1782108 × 108 |
| Variance | 1.9945483 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8 | 5220 | 4.2% |
| 7 | 5064 | 4.0% |
| 6 | 4855 | 3.9% |
| 9 | 4832 | 3.9% |
| 10 | 4317 | 3.4% |
| 11 | 3902 | 3.1% |
| 12 | 3644 | 2.9% |
| 13 | 3285 | 2.6% |
| 14 | 3076 | 2.5% |
| 5 | 2978 | 2.4% |
| Other values (5567) | 84265 |
| Value | Count | Frequency (%) |
| 5 | 2978 | |
| 6 | 4855 | |
| 7 | 5064 | |
| 8 | 5220 | |
| 9 | 4832 | |
| 10 | 4317 | |
| 11 | 3902 | |
| 12 | 3644 | |
| 13 | 3285 | |
| 14 | 3076 |
| Value | Count | Frequency (%) |
| 1326662 | 1 | |
| 1167229 | 1 | |
| 1053088 | 1 | |
| 827972 | 1 | |
| 819891 | 1 | |
| 770703 | 1 | |
| 754833 | 1 | |
| 718854 | 1 | |
| 692508 | 1 | |
| 659750 | 1 |
Auto
The auto setting is an interpretable pairwise column metric of the following mapping:- Variable_type-Variable_type : Method, Range
- Categorical-Categorical : Cramer's V, [0,1]
- Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
- Numerical-Numerical : Spearman's ρ, [-1,1]
This configuration uses the recommended metric for each pair of columns.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| tconst | averageRating | numVotes | |
|---|---|---|---|
| 0 | tt0000003 | 6.5 | 1737 |
| 1 | tt0000033 | 5.5 | 1002 |
| 2 | tt0000035 | 5.5 | 79 |
| 3 | tt0000040 | 4.1 | 64 |
| 4 | tt0000041 | 6.7 | 1787 |
| 5 | tt0000045 | 3.9 | 33 |
| 6 | tt0000046 | 4.1 | 34 |
| 7 | tt0000060 | 7.6 | 87 |
| 8 | tt0000066 | 3.0 | 29 |
| 9 | tt0000067 | 5.6 | 62 |
| tconst | averageRating | numVotes | |
|---|---|---|---|
| 125428 | tt9913636 | 7.4 | 31 |
| 125429 | tt9913862 | 3.6 | 6 |
| 125430 | tt9914156 | 6.4 | 163 |
| 125431 | tt9914162 | 6.2 | 5 |
| 125432 | tt9914392 | 4.9 | 14 |
| 125433 | tt9914758 | 7.4 | 19 |
| 125434 | tt9916120 | 5.3 | 12 |
| 125435 | tt9916316 | 8.4 | 5 |
| 125436 | tt9916576 | 6.1 | 21 |
| 125437 | tt9916580 | 8.5 | 7 |